package com.itheima.dao;

import com.itheima.pojo.CheckItem;
import com.itheima.pojo.Setmeal;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MobileSetmealDao {

    //@Select("select * from t_setmeal")
    public List<Setmeal> getSetmeal();

    //@Select("select * from t_setmeal_checkgroup sc,t_checkgroup c where sc.setmeal_id = #{id} and sc.checkgroup_id = c.id")
    //public List<CheckGroup> getCheckGroup(int id);

    @Select("select * from t_checkgroup_checkitem cg,t_checkitem ci where cg.checkgroup_id = #{id} and ci.id=cg.checkitem_id")
    public List<CheckItem> getCheckItem(int id);

    Setmeal findById(int id);
}
